/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.compra.sql;

/**
 *
 * @author JM
 */
public class SQLEmpresa {

    public static final String BuscarEmpresaCombo = "SELECT id_em, nombre_em FROM empresa";
    public static final String insertEmpresa = "INSERT INTO EMPRESA(nombre_em,direccion_em,nrc_em,giro_em,nit_em,email_em)VALUES(?,?,?,?,?,?)";
    public static final String updateEmpresa = "UPDATE EMPRESA SET nombre_em=?,direccion_em=?,nrc_em=?,giro_em=?,nit_em=?,email_em=? where id_em=?";
    public static final String buscarEmpresa = "SELECT * FROM EMPRESA order by nombre_em";

    public static final String getEmpresa="SELECT * FROM EMPRESA where id_em=?";
}